File manager - Edit - /home/autoph/public_html/projects/app/Http/Controllers/API/v1/LeaveLedgerController.php
Back
<?php namespace App\Http\Controllers\API\v1; use App\Http\Controllers\Controller; use App\Models\LeaveLedger; use Illuminate\Http\Request; use Illuminate\Support\Facades\Auth; use Illuminate\Support\Facades\DB; class LeaveLedgerController extends Controller { public function index(Request $request) { // $employee = Auth::user(); $keyword = $request->input('keyword', ''); $perPage = $request->input('per_page', PHP_INT_MAX); $sortBy = $request->input('sortBy', ''); $sortType = $request->input('sortType', ''); $keyword = str_replace(" ", "%", $keyword); DB::enableQueryLog(); $data = LeaveLedger::with([ 'employee' => fn($employee) => $employee->select('id', 'employee_id', DB::raw('CONCAT(firstname, " ", lastname) as full_name')), 'leave_type' => fn($leave_type) => $leave_type->select('id', 'name', 'enabled'), 'recommending' => fn($recommending) => $recommending->select('employee_id', 'asa_user_id', 'firstname', 'lastname'), 'approving'=> fn($approving) => $approving->select('employee_id', 'asa_user_id', 'firstname', 'lastname'), ]) ->select( 'id', 'employee_id', 'company_id', 'dealer_id', 'leave_id', 'date_from', 'date_to', 'credits_from', 'credits_to', 'credit', 'hours', 'leave_type', 'leave_name', 'date_applied', ) ->where(function ($query) use ($keyword) { if ($keyword) { $query->where('column_name', 'like', "%{$keyword}%"); } }); if ($employee->roles[0]['group_id'] != 1) { $data->where('employee_id', $employee->employee_id); } if (!empty($sortBy) && !empty($sortType)) { $data = $data->orderBy($sortBy, $sortType); } $data = $data->paginate($perPage); // dd($data); $response = [ 'data' => $data ]; return response()->json($response); } public function show(Request $request, $employee_id){ $data = LeaveLedger::where('employee_id', $employee_id)->get(); return response()->json($data); } }
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0 |
proxy
|
phpinfo
|
Settings